[dbo].[Error]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Identity
	ErrorID	int	4	1 - 1
	StackTrace	varchar(2048)	2048
	FriendlyErrorMessage	varchar(1024)	1024
	ErrorType	varchar(1024)	1024
$Indexes iWC: ErrorDate\UserID$	ErrorDate	datetime	8
	HttpRefer	varchar(256)	256
	HttpPath	varchar(512)	512
	HttpHost	varchar(128)	128
	HttpAll	varchar(2048)	2048
$Indexes iWC: ErrorDate\UserID$	UserID	varchar(60)	60
	CookieData	varchar(2048)	2048

	Name	Columns	Unique
	PK_Error	ErrorID
	iWC	ErrorDate, UserID

SQL Script

CREATE TABLE [dbo].[Error]
(
[ErrorID] [int] NOT NULL IDENTITY(1, 1),
[StackTrace] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FriendlyErrorMessage] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ErrorType] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ErrorDate] [datetime] NULL,
[HttpRefer] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HttpPath] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HttpHost] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HttpAll] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserID] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CookieData] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Error] ADD CONSTRAINT [PK_Error] PRIMARY KEY CLUSTERED ([ErrorID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[Error] ([ErrorDate], [UserID]) ON [PRIMARY]
GO